Skip to main content

Field Map Transforms

Field map transforms in SyncNow provide powerful flexibility for handling and transforming content as it moves between systems. Transformations can range from simple data type changes to advanced scripted or plugin-based modifications.

🔢 Change Field Data Type

SyncNow supports various content types from connected systems, and you can transform these types as needed for the target system.

Step-by-Step Guide

  1. Navigate to the Processes Page
    Go to the Processes page.

  2. Open Mapping Entities
    Click the Mapping Entities button.
    If the process inherits a global mapping, press the Edit Global Mapping button.

    Processes

  3. Open Fields Mapping
    Press the Mapping Fields button.

    Global Mappings

  4. Edit the Field Mapping
    Click the Edit button next to the field mapping you wish to change.

    Mapping Fields

  5. Select the Desired Data Type
    Choose the appropriate data type (e.g., Markup Text) from the available options.

  6. Save Changes
    Press the Save button to apply your changes.

    Save Button

🏷️ Set Constant Content

Set a constant value for the target field, regardless of the source content.
This is useful for applying fixed values during synchronization.

🔍 Regular Expression Transform

Use regular expressions to search for patterns in the source field and replace them with another value.
This is ideal for pattern-based data transformations.

🗂️ Picklist Transform

Map values from a source picklist to a target picklist.

Steps:

  1. Use labels as keys if source system keys are not relevant.
  2. If there are duplicate source keys, select which one will be the default for backward synchronization.
  3. Set a default value if nothing is found in the mapping, or raise an error (which will be logged in SyncNow).

Picklist Transform

💻 Scripted Transform

For complex transformations, use inline C# code to programmatically transform field data.

Example:

  • The script receives the source and target entities' fields as input parameters.
  • It can return a result or decide not to update the target field.

Script Transform

🔌 Pluggable Transform

For highly advanced transformations, use custom plugins (DLL files).

Steps:

  1. Upload the Plugin:
    Use the Upload Assembly button to upload your DLL file.
  2. Select the Function:
    Choose the function from the plugin to execute.
  3. API Calls:
    Optionally allow API calls to pass system connector credentials to the plugin.

    Use this feature only with trusted plugin authors, as it grants access to sensitive credentials.

Pluggable Transform

Tip:
Use field map transforms to tailor data synchronization to your business needs, from simple formatting to advanced logic and integrations.